﻿-- 面部修改
CREATE procedure [dbo].[RyFace_Update]
@mbsjlsh bigint,
@sfzh varchar(18) = null,
@xm varchar(10) = null
as
update RyFace_Info
set sfzh=@sfzh,xm=@xm,ppsj=getdate() where mbsjlsh=@mbsjlsh

select mbsjlsh,sfzh,xm,sbryh,cjsj,ppsj from RyFace_Info where mbsjlsh=@mbsjlsh